<%--
    Document   : hipoteca
    Created on : 11-jun-2009, 13:44:52
    Author     : Ale
--%>

<%@page contentType="text/html" pageEncoding="UTF-8" session="false" import="domain.*, planner.*, java.util.Iterator, java.util.Set, java.util.List, java.sql.Date"%>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"
"http://www.w3.org/TR/html4/loose.dtd">

<html>
    <head>
        <meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
        <title>DOMECO</title>
        <link href="style.css" rel="stylesheet" type="text/css">
    </head>
    <body>

        <%if (request.getSession(false) != null) {%>
        <table align="center" width="1000" border="0">
            <tr>
                <td>
                    <div id="menu" align="center"><jsp:include page="./menu principal.jsp"></jsp:include></div>
                    <br>
                    <p id="campoAzul" align="center" valign="middle" width="235px"><span id="blanco">Agua</span><br></p>
                    <span id="azulTitulo"> Contratos y Facturas de Agua</span>

                    <div id="general">
                        <div id="cuenta" align="center" >
                            <%
    Userdom user = (Userdom) request.getSession().getAttribute("user");
    Operations o = new Operations();
    List l = o.getWaterContrList(user);
    String company = "";
    double amount = 0.0;
    boolean ocultar = false;
    if (l.isEmpty()) {
        ocultar = true;
                            %>
                            <br>
                            <br>
                            <p align=right"><span id="rojo"> Noy hay Contratos de Agua</span></p>
                            <%} else {
                                Iterator it1 = l.iterator();
                                while (it1.hasNext()) {
                                    Watercontract e = (Watercontract) it1.next();

                            %>
                            <p align=center"><span id="datosCuenta">Contrato: <%=e.getContract().getNameContract()%>, Compañia: <%=e.getCompany()%></span></p>
                            <%
                                List lw = o.getWaterContrList(user);
                                Iterator it1w = lw.iterator();
                                while (it1w.hasNext()) {
                                    Watercontract we = (Watercontract) it1w.next();
                                    Waterconsumption wCons = new Operations().getLastWaterConsumption(we);
                                    if(wCons != null){

                                    %>
                                    <table id="tabla">
                                <tr id="campoAzul" align="center">
                                    <td width="200px"><span id="blanco">Periodo facturado</span></td>
                                    <td width="200px"><span id="blanco">Compañia</span></td>
                                    <td><span id="blanco" >Cuota( en €)</span></td>
                                </tr>
                                <%
                                                amount = wCons.getConsumption().getAmount();
                                                java.sql.Date from = wCons.getDateFrom();
                                                java.sql.Date to = wCons.getDateTo();
                                                company = we.getCompany();
                                %>
                                <tr id="datosCuenta" align="center">
                                    <td><span><%=from%> --- <%=to%></span></td>
                                    <td><span><%=company%></span></td>
                                    <td><span><%=amount%> €</span></td>
                            </tr></table>
                            <br>
                                    <%
                                  
                                      
                                } else {
                            %> <p align=center"><span id="rojo"> Noy hay Cuotas para este Contrato de Electricidad</span></p> <%            }

        }
    }
                                }

                            %>


                        </div>




                        <div id="barraDer">

                            <div id="accesos">
                                <table align="center">
                                    <tr ><td bgcolor="#79A9D9" align="center" valign="middle" width="235px"><span id="blanco">Accesos frecuentes</span><br></td></tr>
                                </table>

                                <p align="center"><a href="./FrontController?redir=NCA" id="colorEvento"><span>A&ntilde;adir Contrato de Agua</span></a></p>
                                <p align="center">  <a href="./FrontController?redir=NFA" id="colorEvento"><span>A&ntilde;adir Factura de Agua</span></a></p>
                                <%if (!ocultar) {%>            <p align="center">  <a href="./FrontController?redir=MBCA" id="colorEvento"><span onmouseover='this.style.color="#FF9900"' onmouseout='this.style.color="#79A9D9"'>Modificar/Borrar contrato</span></a></p> <%}%>
                            </div>
                            
                            <div id="estadisticas">
                                <table align="center">
                                    <tr ><td bgcolor="#79A9D9" align="center" valign="middle" width="235px"><span id="blanco">Datos actuales</span><br></td></tr>
                                </table>

                                <p align="center" id="colorEvento"><span>Operador  actual: <span id="rojo"><%=company%></span></span></p>
                                <p align="center" id="colorEvento"><span>Consumo ultima factura:<span id="rojo"><%=amount%>€</span></span></p>

                            </div>
                        </div>
                    </div>

                    <div id="abajo" align="center"><p>&copy;   Domeco &mdash; Proyecto Informatico A&ntilde;o 2009 </p></div>
                </td>
            </tr>
        </table>
        <%} else {%>
        <jsp:forward page="./index.jsp"></jsp:forward>
        <%}%>
    </body>
</html>
